Refund 
EntityType  Independent 
Logical Entity Name  Refund 
Default Table Name  FaRefund 
Logical Only  NO 
Owner  dbo 
Definition 
 
Note 
 

Refund Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
RefundId(PK)    INTEGER  NO 
 
StudentAwardId(FK)    INTEGER  NO 
 
StipendSummaryId(FK)    INTEGER  YES 
 
StudentRefundCalculationId(FK)    INTEGER  YES 
 
StudentId(FK)    INTEGER  YES 
 
StudentEnrollmentPeriodId(FK)    INTEGER  YES 
 
Source    CHAR(1)  NO 
 
Amount    NUMERIC(10, 2)  NO 
 
DueDate    DATETIME  YES 
 
SentDate    DATETIME  YES 
 
CheckNumber    VARCHAR(20)  YES 
 
StudentRelationshipAddressId(FK)    INTEGER  YES 
 
Status    CHAR(1)  NO 
 
TermId(FK)    INTEGER  YES 
 
PaymentPeriodId    INTEGER  YES 
 
PaymentPeriodNumber    INTEGER  YES 
 
AcademicYear    NUMERIC(3, 0)  NO 
 
Note    VARCHAR(50)  YES 
 
PellGrantDisbStatus    CHAR(1)  YES 
 
LastModifiedUserId    INTEGER  NO 
 
CreatedDateTime    DATETIME  NO 
 
LastModifiedDateTime    DATETIME  NO 
 
RowVersion    TIMESTAMP/DATE  NO 
 
StudentRt4CalculationId(FK)    INTEGER  YES 
 
StipendScheduleId(FK)    INTEGER  YES 
 
CreatedUserId    INTEGER  YES 
 
FaExportImportFileId    INTEGER  YES 
 
RefundAddressType    CHAR(1)  YES 
 
RefundStudentRelationshipAddressId(FK)    INTEGER  YES 
 
ReturnMethod    CHAR(1)  NO 
 
CommonlineStatus    CHAR(1)  NO 
 
IsAchScheduled    BIT  NO 
 
StudentCreditCardId(FK)    INTEGER  YES 
 
CISReceivedDate    DATETIME  YES 
 
CISCompleteDate    DATETIME  YES 
 
PayeeName    VARCHAR(150)  YES 
 
SaReconcileReturnFundID(FK)    INTEGER  YES 
 
LockedByStaffId    INTEGER  YES 
 
StudentAcademicYearPaymentPeriodId(FK)    INTEGER  YES 
 
StudentAwardId(FK)    INTEGER  YES 
 
StudentCreditCardId(FK)    INTEGER  YES 
 

Refund Keys 
Key Name  Key Type  Keys 
FaRefund_FaStudentAidId_SaRefundCalcId_Status_N_N_N_IDX  Inversion Entry  Source 
Nk_FaRefundSaReconcileReturnFundID  Inversion Entry  SaReconcileReturnFundID 
FaRefund_CLStatus_N_N_IDX  Inversion Entry  CommonlineStatus 
FaRefund_CheckNo_N_N_IDX  Inversion Entry  CheckNumber 
FaRefund_FaStudentAidID_N_N_IDX  Inversion Entry  StudentAwardId 
FaRefund_SaCCID_N_N_IDX  Inversion Entry  StudentCreditCardId 
FaRefund_RefundAddrID_N_N_IDX  Inversion Entry  RefundStudentRelationshipAddressId 
FaRefund_DateDue_Status_Source_N_N_IDX  Inversion Entry  DueDate, Status, Source 
FaRefund_FaRefundID_U_C_IDX  PrimaryKey  RefundId 
FaRefund_FaStudentAyPaymentPeriodId_N_N_IDX  Inversion Entry  StudentAcademicYearPaymentPeriodId 

Refund Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
StudentAward  Non-Identifying  One To Zero or More        StudentAwardId  NO 
StudentAcademicYearPaymentPeriod  Non-Identifying  Zero or One to Zero or More        StudentAcademicYearPaymentPeriodId  NO 
StudentRelationshipAddress  Non-Identifying  Zero or One to Zero or More        RefundStudentRelationshipAddressId  NO 
StudentCreditCard  Non-Identifying  Zero or One to Zero or More        StudentCreditCardId  NO 
ReconcileReturnFund  Non-Identifying  Zero or One to Zero or More        SaReconcileReturnFundID  NO 
StipendSchedule  Non-Identifying  Zero or One to Zero or More        StipendScheduleId  NO 
StipendSummary  Non-Identifying  Zero or One to Zero or More        StipendSummaryId  NO 
Student  Non-Identifying  Zero or One to Zero or More        StudentId  NO 
StudentAward  Non-Identifying  Zero or One to Zero or More        StudentAwardId  NO 
StudentCreditCard  Non-Identifying  Zero or One to Zero or More        StudentCreditCardId  NO 
StudentEnrollmentPeriod  Non-Identifying  Zero or One to Zero or More        StudentEnrollmentPeriodId  NO 
StudentRefundCalculation  Non-Identifying  Zero or One to Zero or More        StudentRefundCalculationId  NO 
StudentRelationshipAddress  Non-Identifying  Zero or One to Zero or More        StudentRelationshipAddressId  NO 
StudentRt4Calculation  Non-Identifying  Zero or One to Zero or More        StudentRt4CalculationId  NO 
Term  Non-Identifying  Zero or One to Zero or More        TermId  NO 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype 
CodGrantDisbursement  Non-Identifying  One To Zero or More          NO 
RefundRefundType  Non-Identifying  One To Zero or More          NO 
CreditCardBatchRefund  Non-Identifying  One To Zero or More          NO 
SaOnlineACHBatchRefund  Non-Identifying  One To Zero or More          NO 
SaRefundNotification_FAA  Non-Identifying  One To Zero or More          NO 
SaRefundNotificationHistory_FAA  Non-Identifying  One To Zero or More          NO 
StudentAccountTransactionPendingCheck  Non-Identifying  One To Zero or More          NO 
AchBatchFileCompanyDetail  Non-Identifying  One To Zero or More          NO 
CreditCardBatchRefund  Non-Identifying  One To Zero or More          NO 
StudentAccountTransaction  Non-Identifying  One To Zero or More          NO 
StudentAccountTransactionPendingCheck  Non-Identifying  One To Zero or More          NO 

Refund Check Constraints 
Check Constraint Name  CheckConstraint 
Chk_FaRefund_RefundAddrType_RefundAddrID  ([RefundAddrType] = 'O' and [RefundAddrID] is not null or ([RefundAddrType] = 'R' or ([RefundAddrType] = 'G' or ([RefundAddrType] = 'S' or ([RefundAddrType] = 'L' or [RefundAddrType] = 'U')))) and [RefundAddrID] is null) 

Refund Where Used - Model Usage 
Mapped Object  Is User Defined?  Denormalization Mappings  Description  Bound Attachments 
Logical
dbo.Refund 
NO       
Physical (Microsoft SQL Server)
dbo.FaRefund 
NO       

Refund Where Used - Submodel Usage 
Model  Submodel Usage 
Logical  Main Model 
Logical  ElectronicPaymentProcessing 
Logical  LedgerCard_Billing 
Logical  Refunds_Stipends 
Physical (Microsoft SQL Server)  Main Model 
Physical (Microsoft SQL Server)  Financial Aid 

Refund Data Movement Rules 
Name  Type  Rule Text/Value